﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace VSWClient.Pages.Tables.L2PDB
{
    /// <summary>
    /// pipe_info  table data
    /// </summary>
    public class PIPE_INFO
    {
        #region field
        public static readonly string tableName = "PIPE_INFO";
        public static readonly string fd_eventNo = "EVENT_NO";
        public static readonly string fd_taskNo = "TASK_NO";
        public static readonly string fd_batchNo = "BATCH_NO";
        public static readonly string fd_stripNo = "STRIP_NO";
        public static readonly string fd_pipeNo = "PIPE_NO";
        public static readonly string fd_stripSeq = "STRIP_SEQ";
        public static readonly string fd_location = "LOCATION";
        public static readonly string fd_dtj = "DTJ";
        public static readonly string fd_length = "LENGTH";
        public static readonly string fd_qualityCode = "QUALITY_CODE";
        public static readonly string fd_sampleReason = "SMP_RS";
        public static readonly string fd_sampleFltLength = "SMP_F_LEN";
        public static readonly string fd_mechanicalLength = "SMP_M_LEN";
        public static readonly string fd_additionalLength = "SMP_A_LEN";
        public static readonly string fd_scrapLength = "SCRAP_LENGTH";
        public static readonly string fd_parameter = "PARAMETER";

        public static readonly string fd_headCut = "HEAD_CUT";
        public static readonly string fd_tailCut = "TAIL_CUT";

        public static readonly string fd_updateTime = "UPDATE_TIME";

        #endregion
        public static void CreatePipeInformation()
        {
            //string sql_1 = string.Format("insert into {0}",tableName);
            //string sql_2 = string.Format("({0},{1},{2},{3},{4},{5}) ",fd_pipeCode,fd_orderCode);
            //string sql_3 = string.Format("values({0},{1})",);

            //StringBuilder strSql = new StringBuilder();
            //strSql.Append("insert into CIT_INFORMANTS(");
            //strSql.Append("ID,USERNAME,PASSWORD,CNAME,SEX,PHONE,CARDID,REMARK,FLAG)");
            //strSql.Append(" values (");
            //strSql.Append(":ID,:USERNAME,:PASSWORD,:CNAME,:SEX,:PHONE,:CARDID,:REMARK,:FLAG)");

        }


    }
}
